◀ Prev · Parts · Full · Next ▶

A package may be saved to a file or to a store with a hierarchical namespace within a SQL Server instance. In either case, the package content is persisted in XML.

Once completed, the designer also allows the user to start the package's execution. Once started, the package may be readily debugged or monitored.

SSIS provides the following built-in transformations:cite-ref-5[5]

• Aggregation

• Audit

• Cache transformcite-ref-6[6]

• Copy/Map

• Data conversion

• Data mining model training

• Data mining query

• Dimension processing

• Derived column

• Export and import column

• For loop container

• Foreach loop container

• (Fuzzy) lookup

• Fuzzy grouping

• OLE DB command

• Partition processing

• Percentage samplingcite-ref-7[7]

• Pivot

• Unpivot

• Row count

• Row sampling

• Row sampling transformation

• Script component

• Slowly changing dimension

• Term extraction

• Term Lookup

◀ Prev · Parts · Full · Next ▶